﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetNotaIngresoByFecha')
	BEGIN
		DROP  GetNotaIngresoByFecha
	END

GO

CREATE Procedure GetNotaIngresoByFecha

	(
		@desde date,
		@hasta date
	)


AS
begin
SELECT
	[notaIngreso].[Descripcion] AS 'Descripcion',
	[notaIngreso].[Estado] AS 'Estado',
	[notaIngreso].[FechaIngreso] AS 'FechaIngreso',
	[notaIngreso].[IdEmpleado] AS 'IdEmpleado',
	[notaIngreso].[IdFactura] AS 'IdFactura',
	[notaIngreso].[IdNotaIngreso] AS 'IdNotaIngreso'
FROM [dbo].[NotaIngreso] [notaIngreso]
where [notaIngreso].[FechaIngreso] between @desde and @hasta
end

GO


GRANT EXEC ON GetNotaIngresoByFecha TO PUBLIC

GO


